def parse(self, response):
        print(response.status)
        biaoti = response.xpath("//div[@class='img']/@style").getall()
        print(biaoti)
        xzcs = response.xpath("//p[@class='title ellipsis2']/text()").getall()
        print(xzcs)
        tplj = response.xpath("//a[@class='item free ']/p[2]/text()").getall()
        print(tplj)
        danjia = response.xpath("//span[@class='l']/text()").getall()
        print(danjia)
        dataSet={}
        for i,j,s,x in zip(biaoti,xzcs,tplj,danjia):
            dataSet['biaoti'] = i
            dataSet['xzcs'] = j
            dataSet['tplj'] = s
            dataSet['danjia'] = x
            yield dataSet

def insert_item(self,item):
        values = (
            item['biaoti'],
            item['xzcs'],
            item['tplj'],
            item['danjia']
        )
        sql = 'INSERT INTO lesson VALUES(?,?,?,?)'
        self.cursor.execute(sql, values)

def parse(self, response):
        print(response.status)
        biaoti = response.xpath("//dl[@class='dlbox']/dd/ul/li/h2/a/text()").getall()
        print(biaoti)
        xzcs = response.xpath("//ul[@class='tplist']/li/span/text()[2]").getall()
        print(xzcs)
        tplj = response.xpath("//ul[@class='tplist']/li/a/img/@src").getall()
        print(tplj)
        dataSet={}
        for i,j,s in zip(biaoti,xzcs,tplj):
            dataSet['biaoti'] = i
            dataSet['xzcs'] = j
            dataSet['tplj'] = s
            yield dataSet

    def insert_item(self,item):
        values = (
            item['biaoti'],
            item['xzcs'],
            item['tplj']
        )
        sql = 'INSERT INTO lesson1 VALUES(?,?,?)'
        self.cursor.execute(sql, values)


def parse(self, response):
        print(response.status)
        biaoti = response.xpath("//div[@class='title']/a/text()").getall()
        print(biaoti)
        xzcs = response.xpath("//div[@class='houseInfo']/text()").getall()
        print(xzcs)
        tplj = response.xpath("//div[@class='totalPrice totalPrice2']/span/text()").getall()
        print(tplj)
        danjia = response.xpath("//div[@class='unitPrice']/span/text()").getall()
        print(danjia)
        dataSet={}
        for i,j,s,x in zip(biaoti,xzcs,tplj,danjia):
            dataSet['biaoti'] = i
            dataSet['xzcs'] = j
            dataSet['tplj'] = s
            dataSet['danjia'] = x
            yield dataSet

def insert_item(self,item):
        values = (
            item['biaoti'],
            item['xzcs'],
            item['tplj'],
            item['danjia']
        )
        sql = 'INSERT INTO lesson2 VALUES(?,?,?,?)'
        self.cursor.execute(sql, values)

def parse(self, response):
        print(response.status)
        biaoti = response.xpath("//p[@class='name text-elli-one']/text()").getall()
        print(biaoti)
        xzcs = response.xpath("//p[@class='score']/span/text()").getall()
        print(xzcs)
        tplj = response.xpath("//p[@class='comm_num']/text()").getall()
        print(tplj)
        danjia = response.xpath("//p[@class='price']/text()").getall()
        print(danjia)
        dataSet={}
        for i,j,s,x in zip(biaoti,xzcs,tplj,danjia):
            dataSet['biaoti'] = i
            dataSet['xzcs'] = j
            dataSet['tplj'] = s
            dataSet['danjia'] = x
            yield dataSet

def insert_item(self,item):
        values = (
            item['biaoti'],
            item['xzcs'],
            item['tplj'],
            item['danjia']
        )
        sql = 'INSERT INTO lesson3 VALUES(?,?,?,?)'
        self.cursor.execute(sql, values)


def parse(self, response):
        print(response.status)
        xhtml = response.json()
        for i in range(50):
            xzcs = xhtml['payload']['players'][i]['playerProfile']['displayName']
            tplj = xhtml['payload']['players'][i]['teamProfile']['displayAbbr']
            danjia = xhtml['payload']['players'][i]['statAverage']['pointsPg']
            dataSet={}
            dataSet['xzcs'] = xzcs
            dataSet['tplj'] = tplj
            dataSet['danjia'] = danjia
            yield dataSet
            
    def insert_item(self,item):
        values = (
            item['xzcs'],
            item['tplj'],
            item['danjia']
        )
        sql = 'INSERT INTO lesson4 VALUES(?,?,?)'
        self.cursor.execute(sql, values)